package cn.wolfcode.mapper;

import cn.wolfcode.domain.Dept;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;


public interface DeptMapper {
    @Select("select * from dept")
    List<Dept> list();
    @Delete("delete from dept where id=#{id}")
    void delete(Long id);
    @Insert("""
            insert into dept (name,create_time,update_time) 
            values (#{name},#{createTime},#{updateTime})
            """)
    void add(Dept dept);
    @Select("select * from dept where id=#{id}")
    Dept findById(Long id);
    @Update("update dept set name = #{name},update_time=#{updateTime} " +
            "where id=#{id}")
    void update(Dept dept);
}
